Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Sequence Indentity
1) A table could also be created so that the seed value was negative and the increment was positive
2) Altering the Table to Add an Identity Column
3) Cannot insert explicit value for identity column in table T when IDENTITY_INSERT is set to OFF
4) Check @@IDENTITY value
5) Create table with IDENTITY column
6) Discover what the last IDENTITY value
7) Generating IDENTITY values
8) IDENTITY(100, 20)
9) IDENTITYNOT NULLPRIMARY KEY
10) Identity
11) Identity column
12) Identity Property
13) Last identity value generated for any table in the current session, for the current scope
14) Query a view with four table join
15) Query that Returns Result Row Numbers, Starting with 1 and Incrementing by 3
16) Retrieving the Maximum Value of key_col from MyTable
17) Retrieving the Seed and Increment Values
18) Returning an Identity Columns Seed and Incrementing Value
19) Saving the @@IDENTITY Value in a Variable
20) SELECT IDENT_CURRENT(customer)
21) SELECT IDENTITYCOL FROM yourTable
22) SELECT SCOPE_IDENTITY()
23) SELECT Statement and IDENTITY Property
24) SET IDENTITY_INSERT Employee ON
25) SQL Server provides the @@IDENTITY global variable to hold that value
26) SQL Server will choose the highest number as its current seed for a positive increment value or the lowest for a negati
27) Storing the Results in a Temporary Table Using the IDENTITY() Function
28) Supported data types for the IDENTITY property are TinyInt, SmallInt Int, BigInt, Decimal, and Numeric
29) Syntax for Using the IDENTITY() Function
30) The IDENT_SEED function displays the originally defined seed value for the IDENTITY column of a specific table or refer
31) The IDENTITY property must be temporarily turned off when inserting a specific value
32) Using the IDENTITY Property and the IDENTITY() Function
33) Using the IDENTITY_INSERT Session Option
34) Using the IDENTITYCOL Keyword
35) Using the SCOPE_IDENTITY() Function